*** Create Table 1, Summary Statistics ***

********************************************************************************
clear 

** read in .dta file **
use "${clean}/who_counts_analysis.dta", clear



** read in analysis cohort: as noted in the paper this excludes the following groups: those born abroad, non-citizens, non residents, and respondents in provinces formerly administered by Spain ** 

preserve

** Table 1 focuses only on 10 year cohort. First drop all individuals born after 1955 **
drop if YOB > 1955


estpost sum MOB EDU_YRS French_Lit Schooling TREATED Arabic Female ANY_FOR ec_total n_classes52 n_schools52 n_students52 Coastal elev_mean cropland1910 popd_1910
esttab . using "${output}/tables/Table1.tex", varlabels(MOB "Reported Month of Birth" Schooling "Any Formal Schooling " French_Lit "Literate in French and Arabic " EDU_YRS "Years of Formal Education " Arabic "Native Language Arabic " Female "Woman " elev_mean "Mean Elevation " cropland1910 "Estimated pre-Colonial Cropland" popd_1910 "Estimated pre-Colonial Population Density" TREATED "Born After 1950" ANY_FOR "Urban Foreigners, 1950" ec_total "No. Civil Registry Offices " n_classes52 "No. Muslim Primary Classrooms, 1952" n_schools52 "No. Muslim Primary Schools, 1952" n_students52 "No. Muslim Students, 1952") booktabs title(Summary Statistics, (1945-1955) \label{tab:Descriptives_BW1}) cells("count(fmt(3)) mean(fmt(3)) sd(fmt(3)) min(fmt(3)) max(fmt(3))") replace nomtitle nonum


restore
